#!/bin/sh


                                                                                                                                          
userid=            
echo "Enter User ID, (username in AD)"                                                                                                    
read userid
                                                                                                                                          
fullname=
echo "Enter Fullname (Givenname Surname)"                                                                                                 
read fullname
                                                                                                                                          
pnr=
echo "Enter Personal numer (swedish personnummer)"                                                                                        
read pnr
                                                                                                                                          
epost=
echo "Enter E-mail (foo@bar.se)"                                                                                                          
read epost
echo "insert into persondata (namn,pnr,epost,uid) VALUES('$fullname','$pnr','$epost','$userid');" | mysql persondata -u root -p 
#echo "select * from persondata;" | mysql persondata -u root -p


